Steps to create a Scatter Plot with Dynamic Reference line (Target/ Goal) 13

       i.      While you are at the data source window Click on New worksheet at the status bar of Tableau Window.

       ii.      A new window will open with Sheet #, Rename it... Eg: Scatterplot.   

     iii.      Drag and Drop First Contact Resolution Rate Form Measures to Columns.

              iv.      Drag and Drop Time to Close Days from Measures to Rows.

                v.      By Default, the chart type will be selected to Automatic, Change it to Circle.

 Visual Steps i-v


            vi.      Drag and drop Agent Name to Detail

          vii.      Drag Agent Name again and drop to Label this time.

         viii.      Drag and drop Ticket ID to Size and change measure to Count Distinct.

 Visual Steps vi-viii

        ix.   Create TTC_Goal Parameter 

a.        Click down Arrow Next to Dimensions

b.        Click Parameters

c.         In a Create Parameter Dialog box Provide Name Avg_TTC_Goal

d.         Change the Data Type to Integer

e.         Provide Current value 0

f.           Select Allowable values as Range

g.        Check Minimum and change value to 0 if it is not already changed.

h.        Check Maximum and change value to 20

i.         Check Step Size and change value to 1

                 j.         OK

                k.         Right Click Avg_TTC_Goal parameter and select Show Parameter Control.

        Visual Steps ix (a-k)


x.      Create  Avg_FCRR_Goal Parameter

a.    Click down Arrow Next to Dimensions

b.    Click Parameters

c.     In a Create Parameter Dialog box Provide Name Avg_FCRR_Goal

d.    Leave the Data Type as Float

e.    Leave the Current value 1 for the moment.

f.      Select Allowable values as Range

g.     Check Minimum and change value to 0 if it is not already changed.

h.     Check Maximum and change value to 1

 i.     Check Step Size and change value to .05

j.     Change the Current Value to 0.4

k.   Click OK

l.    Right click Avg_ FCRR_Goal parameter and Select Show Parameter Control.

Visual Steps x (a-l)



        xi.   Create Calculated Field to add 4 dynamic quadrants in the chart.

a.          Click on Analysis and then Click Calculated Field

b.        Rename it to Quadrants. 

c.        Copy and Paste the Code below for Quadrants logic:

                    IF      AVG([Time To Close Days])<= [Avg_TTC_Goal] and AVG([First Contact Resolution Rate]) <= [Avg_FCRR_Goal] THEN 'Below Avg_TTC, Below Avg_FCRR'

                    ELSEIF  AVG([Time To Close Days])> [Avg_TTC_Goal] and AVG([First Contact Resolution Rate]) <=[Avg_FCRR_Goal] THEN 'Above Avg_TTC, Below Avg_FCRR'

                    ELSEIF  AVG([Time To Close Days])<= [Avg_TTC_Goal] and AVG([First Contact Resolution Rate]) > [Avg_FCRR_Goal] THEN 'Below Avg_TTC, Above Avg_FCRR'

                    ELSEIF  AVG([Time To Close Days])> [Avg_TTC_Goal] and AVG([First Contact Resolution Rate]) > [Avg_FCRR_Goal]  THEN 'Above Avg_TTC, Above Avg_FCRR'

                    END

 

        xii.   Drag and Drop the recently created calculated field (Quadrants) to the Color

Visual Steps xi & xii



 

        xiii.   Right Click on the Y-axis and select add Reference Line.

                    a. Click on Drop down arrow for Value

                    b. Select Avg_TTC_Goal Parameter

        xiv.   Right click on the X-axis and Select Add reference line.

                         a.     Click on Drop down arrow for Value

                          b.     Select Avg_FCRR_Goal Parameter


        Visual Steps xiii-xiv 

  


 

        xvii.   Edit  the Color for the Quadrants as Follows:

a.        Above Avg_TTC, Below Avg_FCRR = Red

 b.     Above Avg_TTC, Above Avg_FCRR = Yellow

  c.    Below Avg_TTC, Above Avg_FCRR= Green

  d.   Below Avg_TTC, Below Avg_FCRR= Yellow

      xviii.   Click on Count Ticket ID and Click on Size, then Increase the bubble to the desired size.

           Visual Steps xvii & Xviii

        

          

Steps to create a Scatter Plot with Dynamic Reference line (Target/ Goal) 13

       i.      While you are at the data source window Click on New worksheet at the status bar of Tableau Window.

       ii.      A new window will open with Sheet #, Rename it... Eg: Scatterplot.   

     iii.      Drag and Drop First Contact Resolution Rate Form Measures to Columns.

              iv.      Drag and Drop Time to Close Days from Measures to Rows.

                v.      By Default, the chart type will be selected to Automatic, Change it to Circle.

 Visual Steps i-v


            vi.      Drag and drop Agent Name to Detail

          vii.      Drag Agent Name again and drop to Label this time.

         viii.      Drag and drop Ticket ID to Size and change measure to Count Distinct.

 Visual Steps vi-viii

        ix.   Create TTC_Goal Parameter 

a.        Click down Arrow Next to Dimensions

b.        Click Parameters

c.         In a Create Parameter Dialog box Provide Name Avg_TTC_Goal

d.         Change the Data Type to Integer

e.         Provide Current value 0

f.           Select Allowable values as Range

g.        Check Minimum and change value to 0 if it is not already changed.

h.        Check Maximum and change value to 20

i.         Check Step Size and change value to 1

                 j.         OK

                k.         Right Click Avg_TTC_Goal parameter and select Show Parameter Control.

        Visual Steps ix (a-k)


x.      Create  Avg_FCRR_Goal Parameter

a.    Click down Arrow Next to Dimensions

b.    Click Parameters

c.     In a Create Parameter Dialog box Provide Name Avg_FCRR_Goal

d.    Leave the Data Type as Float

e.    Leave the Current value 1 for the moment.

f.      Select Allowable values as Range

g.     Check Minimum and change value to 0 if it is not already changed.

h.     Check Maximum and change value to 1

 i.     Check Step Size and change value to .05

j.     Change the Current Value to 0.4

k.   Click OK

l.    Right click Avg_ FCRR_Goal parameter and Select Show Parameter Control.

Visual Steps x (a-l)



        xi.   Create Calculated Field to add 4 dynamic quadrants in the chart.

a.          Click on Analysis and then Click Calculated Field

b.        Rename it to Quadrants. 

c.        Copy and Paste the Code below for Quadrants logic:

                    IF      AVG([Time To Close Days])<= [Avg_TTC_Goal] and AVG([First Contact Resolution Rate]) <= [Avg_FCRR_Goal] THEN 'Below Avg_TTC, Below Avg_FCRR'

                    ELSEIF  AVG([Time To Close Days])> [Avg_TTC_Goal] and AVG([First Contact Resolution Rate]) <=[Avg_FCRR_Goal] THEN 'Above Avg_TTC, Below Avg_FCRR'

                    ELSEIF  AVG([Time To Close Days])<= [Avg_TTC_Goal] and AVG([First Contact Resolution Rate]) > [Avg_FCRR_Goal] THEN 'Below Avg_TTC, Above Avg_FCRR'

                    ELSEIF  AVG([Time To Close Days])> [Avg_TTC_Goal] and AVG([First Contact Resolution Rate]) > [Avg_FCRR_Goal]  THEN 'Above Avg_TTC, Above Avg_FCRR'

                    END

 

        xii.   Drag and Drop the recently created calculated field (Quadrants) to the Color

Visual Steps xi & xii



 

        xiii.   Right Click on the Y-axis and select add Reference Line.

                    a. Click on Drop down arrow for Value

                    b. Select Avg_TTC_Goal Parameter

        xiv.   Right click on the X-axis and Select Add reference line.

                         a.     Click on Drop down arrow for Value

                          b.     Select Avg_FCRR_Goal Parameter


        Visual Steps xiii-xiv 

  


 

        xvii.   Edit  the Color for the Quadrants as Follows:

a.        Above Avg_TTC, Below Avg_FCRR = Red

 b.     Above Avg_TTC, Above Avg_FCRR = Yellow

  c.    Below Avg_TTC, Above Avg_FCRR= Green

  d.   Below Avg_TTC, Below Avg_FCRR= Yellow

      xviii.   Click on Count Ticket ID and Click on Size, then Increase the bubble to the desired size.

           Visual Steps xvii & Xviii